package cn.edu.sdjzu.xg23.kcsj01_backend.mapper;


import cn.edu.sdjzu.xg23.kcsj01_backend.entity.ApprovalDepartment;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ApprovalDepartmentMapper {
    @Select("SELECT * FROM approval_department WHERE id = #{id}")
    ApprovalDepartment getApprovalDepartmentById(Long id);

    @Select("SELECT id, name FROM approval_department")
    List<ApprovalDepartment> getAllApprovalDepartments();
}
